set DATEFORMAT dmy

CREATE TABLE EMPLOYEE (
  employee_id SMALLINT NOT NULL PRIMARY KEY,
  last_name VARCHAR(15),
  first_name VARCHAR(15),
  middle_initial VARCHAR(1),
  manager_id SMALLINT,
  job_id SMALLINT,
  hire_date DATETIME,
  salary NUMERIC(7,2),
  commission NUMERIC(7,2),
  department_id SMALLINT  );

CREATE TABLE DEPARTMENT (
  department_id SMALLINT NOT NULL PRIMARY KEY,
  name VARCHAR(14),
  location_id SMALLINT );


CREATE TABLE LOCATION (
  location_id SMALLINT NOT NULL PRIMARY KEY,
  regional_group VARCHAR(20) );

CREATE TABLE JOB  (
  job_id SMALLINT NOT NULL PRIMARY KEY,
  "function" VARCHAR(30) );

CREATE TABLE CUSTOMER (
  customer_id INTEGER NOT NULL PRIMARY KEY,
  name VARCHAR(45),
  address VARCHAR(40),
  city VARCHAR(30),
  state VARCHAR(2),
  zip_code VARCHAR(9),
  area_code SMALLINT,
  phone_number INTEGER,
  salesperson_id SMALLINT,
  credit_limit NUMERIC(9,2), 
  comments VARCHAR(500) );

CREATE TABLE SALES_ORDER (
  order_id SMALLINT NOT NULL PRIMARY KEY,
  order_date DATETIME,
  customer_id INTEGER,
  ship_date DATETIME,
  total NUMERIC(8,2) );

CREATE TABLE ITEM (
  order_id SMALLINT NOT NULL,
  item_id SMALLINT NOT NULL,
  product_id INTEGER,
  actual_price NUMERIC(8,2),
  quantity INTEGER,
  total NUMERIC(8,2),
PRIMARY KEY (order_id,item_id)
);

CREATE TABLE PRODUCT (
  product_id INTEGER NOT NULL PRIMARY KEY,
  description VARCHAR(30) );

CREATE TABLE PRICE (
  product_id INTEGER NOT NULL,
  list_price NUMERIC(8,2),
  min_price NUMERIC(8,2),
  start_date DATETIME NOT NULL,
  end_date DATETIME,
  PRIMARY KEY (product_id,start_date)
);

INSERT INTO customer VALUES(100,'JOCKSPORTS','345 VIEWRIDGE','BELMONT','CA','96711',415,5986609,7844,5000,'Very friendly people to work with -- sales rep likes to be called Mike.');
INSERT INTO customer VALUES(101,'TKB SPORT SHOP','490 BOLI RD.','REDWOOD CITY','CA','94061',415,3681223,7521,10000,'Rep called 5/8 about change in order - contact shipping.');
INSERT INTO customer VALUES(102,'VOLLYRITE','9722 HAMILTON','BURLINGAME','CA','95133',415,6443341,7654,7000,'Company doing heavy promotion beginning 10/89. Prepare for large orders during w');
INSERT INTO customer VALUES(103,'JUST TENNIS','HILLVIEW MALL','BURLINGAME','CA','97544',415,6779312,7521,3000,'Contact rep about new line of tennis rackets.');
INSERT INTO customer VALUES(104,'EVERY MOUNTAIN','574 SURRY RD.','CUPERTINO','CA','93301',408,9962323,7499,10000,'Customer with high market share (23%) due to aggressive advertising.');
INSERT INTO customer VALUES(105,'K + T SPORTS','3476 EL PASEO','SANTA CLARA','CA','91003',408,3769966,7844,5000,'Tends to order large amounts of merchandise at once. Accounting is considering r');
INSERT INTO customer VALUES(106,'SHAPE UP','908 SEQUOIA','PALO ALTO','CA','94301',415,3649777,7521,6000,'Support intensive. Orders small amounts (< 800) of merchandise at a time.');
INSERT INTO customer VALUES(107,'WOMENS SPORTS','VALCO VILLAGE','SUNNYVALE','CA','93301',408,9674398,7499,10000,'First sporting goods store geared exclusively towards women. Unusual promotional');
INSERT INTO customer VALUES(108,'NORTH WOODS HEALTH AND FITNESS SUPPLY CENTER','98 LONE PINE WAY','HIBBING','MN','55649',612,5669123,7844,8000,'');
INSERT INTO customer VALUES(201,'STADIUM SPORTS','47 IRVING PL.','NEW YORK','NY','10003',212,5555335,7557,10000,'Large general-purpose sports store with an affluent customer base.');
INSERT INTO customer VALUES(202,'HOOPS','2345 ADAMS AVE.','LEICESTER','MA','01524',508,5557542,7820,5000,'Specializes in basketball equipment.');
INSERT INTO customer VALUES(203,'REBOUND SPORTS','2 E. 14TH ST.','NEW YORK','NY','10009',212,5555989,7557,10000,'Follow up on the promotion proposal.');
INSERT INTO customer VALUES(204,'THE POWER FORWARD','1 KNOTS LANDING','DALLAS','TX','75248',214,5550505,7560,12000,'Large floorspace.  Prefers maintaining large amounts of inventory on hand.');
INSERT INTO customer VALUES(205,'POINT GUARD','20 THURSTON ST.','YONKERS','NY','10956',914,5554766,7557,3000,'Tremendous potential for an exclusive agreement.');
INSERT INTO customer VALUES(206,'THE COLISEUM','5678 WILBUR PL.','SCARSDALE','NY','10583',914,5550217,7557,6000,'Contact rep. about new product lines.');
INSERT INTO customer VALUES(207,'FAST BREAK','1000 HERBERT LN.','CONCORD','MA','01742',508,5551298,7820,7000,'Customer requires written price quotes before making purchase requisitions.');
INSERT INTO customer VALUES(208,'AL AND BOB''S SPORTS','260 YORKTOWN CT.','AUSTIN','TX','78731',512,5557631,7560,4000,'Very personal purchasing agents -- Sharon and Scott.');
INSERT INTO customer VALUES(211,'AT BAT','234 BEACHEM ST.','BROOKLINE','MA','02146',617,5557385,7820,8000,'Have an open purchase order for $3000.  Ship immediately on request.');
INSERT INTO customer VALUES(212,'ALL SPORT','1000 38TH ST.','BROOKLYN','NY','11210',718,5551739,7600,6000,'Pursue a contract -- possible candidate for volume purchasing agreements.');
INSERT INTO customer VALUES(213,'GOOD SPORT','400 46TH ST.','SUNNYSIDE','NY','11104',718,5553771,7600,5000,'May be moving to a larger location.');
INSERT INTO customer VALUES(214,'AL''S PRO SHOP','45 SPRUCE ST.','SPRING','TX','77388',713,5555172,7564,8000,'Target market is serious athletes.');
INSERT INTO customer VALUES(215,'BOB''S FAMILY SPORTS','400 E. 23RD','HOUSTON','TX','77026',713,5558015,7654,8000,'Target market is casual and weekend athletes.  Offers a large selection.');
INSERT INTO customer VALUES(216,'THE ALL AMERICAN','547 PRENTICE RD.','CHELSEA','MA','02150',617,5553047,7820,5000,'Customer prefers to be called between 10 and 12.');
INSERT INTO customer VALUES(217,'HIT, THROW, AND RUN','333 WOOD COURT','GRAPEVINE','TX','76051',817,5552352,7564,6000,'General purpose sports store.');
INSERT INTO customer VALUES(218,'THE OUTFIELD','346 GARDEN BLVD.','FLUSHING','NY','11355',718,5552131,7820,4000,'Store does not open until 11am and does not have an answering service.');
INSERT INTO customer VALUES(221,'WHEELS AND DEALS','2 MEMORIAL DRIVE','HOUSTON','TX','77007',713,5554139,7789,10000,'Discount bicycle and sporting good store.');
INSERT INTO customer VALUES(222,'JUST BIKES','4000 PARKRIDGE BLVD.','DALLAS','TX','75205',214,5558735,7789,4000,'Exclusive bicycle dealer.');
INSERT INTO customer VALUES(223,'VELO SPORTS','23 WHITE ST.','MALDEN','MA','02148',617,5554983,7820,5000,'Clerk answers all phone lines.  Ask for Mike.');
INSERT INTO customer VALUES(224,'JOE''S BIKE SHOP','4500 FOX COURT','GRAND PRARIE','TX','75051',214,5559834,7789,6000,'Call Joe to make sure last shipment was complete.');
INSERT INTO customer VALUES(225,'BOB''S SWIM, CYCLE, AND RUN','300 HORSECREEK CIRCLE','IRVING','TX','75039',214,5558388,7789,7000,'Store catering to triathletes.');
INSERT INTO customer VALUES(226,'CENTURY SHOP','8 DAGMAR DR.','HUNTINGTON','NY','11743',516,5553006,7555,4000,'Customer in the midst of a cost-cutting program.');
INSERT INTO customer VALUES(227,'THE TOUR','2500 GARDNER RD.','SOMERVILLE','MA','02144',617,5556673,7820,5000,'Customer referred to us by The All American.');
INSERT INTO customer VALUES(228,'FITNESS FIRST','5000 85TH ST.','JACKSON HEIGHTS','NY','11372',718,5558710,7555,4000,'Recently acquired another sporting goods store.  Expect higher volume in the fut');

INSERT INTO department VALUES(10,'ACCOUNTING',122);
INSERT INTO department VALUES(20,'RESEARCH',124);
INSERT INTO department VALUES(30,'SALES',123);
INSERT INTO department VALUES(40,'OPERATIONS',167);
INSERT INTO department VALUES(12,'RESEARCH',122);
INSERT INTO department VALUES(13,'SALES',122);
INSERT INTO department VALUES(14,'OPERATIONS',122);
INSERT INTO department VALUES(23,'SALES',124);
INSERT INTO department VALUES(24,'OPERATIONS',124);
INSERT INTO department VALUES(34,'OPERATIONS',123);
INSERT INTO department VALUES(43,'SALES',167);

INSERT INTO employee (EMPLOYEE_ID,LAST_NAME,FIRST_NAME,MIDDLE_INITIAL,JOB_ID,MANAGER_ID,HIRE_DATE,SALARY,DEPARTMENT_ID) VALUES(7369,'SMITH','JOHN','Q',667,7902,'17/12/1984',800,20);
INSERT INTO employee VALUES(7499,'ALLEN','KEVIN','J',7698,670,'20/02/1985',1600,300,30);
INSERT INTO employee (EMPLOYEE_ID,LAST_NAME,FIRST_NAME,MIDDLE_INITIAL,JOB_ID,MANAGER_ID,HIRE_DATE,SALARY,DEPARTMENT_ID) VALUES(7505,'DOYLE','JEAN','K',671,7839,'04/04/1985',2850,13);
INSERT INTO employee (EMPLOYEE_ID,LAST_NAME,FIRST_NAME,MIDDLE_INITIAL,JOB_ID,MANAGER_ID,HIRE_DATE,SALARY,DEPARTMENT_ID) VALUES(7506,'DENNIS','LYNN','S',671,7839,'15/05/1985',2750,23);
INSERT INTO employee (EMPLOYEE_ID,LAST_NAME,FIRST_NAME,MIDDLE_INITIAL,JOB_ID,MANAGER_ID,HIRE_DATE,SALARY,DEPARTMENT_ID) VALUES(7507,'BAKER','LESLIE','D',671,7839,'10/06/1985',2200,14);
INSERT INTO employee VALUES(7521,'WARD','CYNTHIA','D',7698,670,'22/02/1985',1250,500,30);
INSERT INTO employee VALUES(7555,'PETERS','DANIEL','T',7505,670,'31/03/1985',1250,300,13);
INSERT INTO employee VALUES(7557,'SHAW','KAREN','P',7505,670,'02/04/1985',1250,1200,13);
INSERT INTO employee (EMPLOYEE_ID,LAST_NAME,FIRST_NAME,MIDDLE_INITIAL,JOB_ID,MANAGER_ID,HIRE_DATE,SALARY,DEPARTMENT_ID) VALUES(7560,'DUNCAN','SARAH','S',670,7506,'31/05/1985',1250,23);
INSERT INTO employee VALUES(7564,'LANGE','GREGORY','J',7506,670,'01/06/1985',1250,300,23);
INSERT INTO employee (EMPLOYEE_ID,LAST_NAME,FIRST_NAME,MIDDLE_INITIAL,JOB_ID,MANAGER_ID,HIRE_DATE,SALARY,DEPARTMENT_ID) VALUES(7566,'JONES','TERRY','M',671,7839,'02/04/1985',2975,20);
INSERT INTO employee (EMPLOYEE_ID,LAST_NAME,FIRST_NAME,MIDDLE_INITIAL,JOB_ID,MANAGER_ID,HIRE_DATE,SALARY,DEPARTMENT_ID) VALUES(7569,'ALBERTS','CHRIS','L',671,7839,'06/04/1985',3000,12);
INSERT INTO employee VALUES(7600,'PORTER','RAYMOND','Y',7505,670,'15/04/1985',1250,900,13);
INSERT INTO employee (EMPLOYEE_ID,LAST_NAME,FIRST_NAME,MIDDLE_INITIAL,JOB_ID,MANAGER_ID,HIRE_DATE,SALARY,DEPARTMENT_ID) VALUES(7609,'LEWIS','RICHARD','M',668,7507,'16/04/1985',1800,24);
INSERT INTO employee VALUES(7654,'MARTIN','KENNETH','J',7698,670,'28/09/1985',1250,1400,30);
INSERT INTO employee (EMPLOYEE_ID,LAST_NAME,FIRST_NAME,MIDDLE_INITIAL,JOB_ID,MANAGER_ID,HIRE_DATE,SALARY,DEPARTMENT_ID) VALUES(7676,'SOMMERS','DENISE','D',668,7507,'19/04/1985',1850,34);
INSERT INTO employee (EMPLOYEE_ID,LAST_NAME,FIRST_NAME,MIDDLE_INITIAL,JOB_ID,MANAGER_ID,HIRE_DATE,SALARY,DEPARTMENT_ID) VALUES(7698,'BLAKE','MARION','S',671,7839,'01/05/1985',2850,30);
INSERT INTO employee (EMPLOYEE_ID,LAST_NAME,FIRST_NAME,MIDDLE_INITIAL,JOB_ID,MANAGER_ID,HIRE_DATE,SALARY,DEPARTMENT_ID) VALUES(7782,'CLARK','CAROL','F',671,7839,'09/06/1985',2450,10);
INSERT INTO employee (EMPLOYEE_ID,LAST_NAME,FIRST_NAME,MIDDLE_INITIAL,JOB_ID,MANAGER_ID,HIRE_DATE,SALARY,DEPARTMENT_ID) VALUES(7788,'SCOTT','DONALD','T',669,7566,'09/12/1986',3000,20);
INSERT INTO employee VALUES(7789,'WEST','LIVIA','N',7506,670,'04/04/1985',1500,1000,23);
INSERT INTO employee (EMPLOYEE_ID,LAST_NAME,FIRST_NAME,MIDDLE_INITIAL,JOB_ID,MANAGER_ID,HIRE_DATE,SALARY,DEPARTMENT_ID) VALUES(7799,'FISHER','MATTHEW','G',669,7569,'12/12/1986',3000,12);
INSERT INTO employee VALUES(7820,'ROSS','PAUL','S',7505,670,'01/06/1985',1300,800,43);
INSERT INTO employee (EMPLOYEE_ID,LAST_NAME,FIRST_NAME,MIDDLE_INITIAL,JOB_ID,HIRE_DATE,SALARY,DEPARTMENT_ID) VALUES(7839,'KING','FRANCIS','A',672,'17/11/1985',5000,10);
INSERT INTO employee VALUES(7844,'TURNER','MARY','A',7698,670,'08/09/1985',1500,0,30);
INSERT INTO employee (EMPLOYEE_ID,LAST_NAME,FIRST_NAME,MIDDLE_INITIAL,JOB_ID,MANAGER_ID,HIRE_DATE,SALARY,DEPARTMENT_ID) VALUES(7876,'ADAMS','DIANE','G',667,7788,'12/01/1987',1100,20);
INSERT INTO employee (EMPLOYEE_ID,LAST_NAME,FIRST_NAME,MIDDLE_INITIAL,JOB_ID,MANAGER_ID,HIRE_DATE,SALARY,DEPARTMENT_ID) VALUES(7900,'JAMES','FRED','S',667,7698,'03/12/1985',950,30);
INSERT INTO employee (EMPLOYEE_ID,LAST_NAME,FIRST_NAME,MIDDLE_INITIAL,JOB_ID,MANAGER_ID,HIRE_DATE,SALARY,DEPARTMENT_ID) VALUES(7902,'FORD','JENNIFER','D',669,7566,'03/12/1985',3000,20);
INSERT INTO employee (EMPLOYEE_ID,LAST_NAME,FIRST_NAME,MIDDLE_INITIAL,JOB_ID,MANAGER_ID,HIRE_DATE,SALARY,DEPARTMENT_ID) VALUES(7916,'ROBERTS','GRACE','M',669,7569,'04/01/1987',2875,12);
INSERT INTO employee (EMPLOYEE_ID,LAST_NAME,FIRST_NAME,MIDDLE_INITIAL,JOB_ID,MANAGER_ID,HIRE_DATE,SALARY,DEPARTMENT_ID) VALUES(7919,'DOUGLAS','MICHAEL','A',667,7799,'04/01/1987',800,12);
INSERT INTO employee (EMPLOYEE_ID,LAST_NAME,FIRST_NAME,MIDDLE_INITIAL,JOB_ID,MANAGER_ID,HIRE_DATE,SALARY,DEPARTMENT_ID) VALUES(7934,'MILLER','BARBARA','M',667,7782,'23/01/1986',1300,10);
INSERT INTO employee (EMPLOYEE_ID,LAST_NAME,FIRST_NAME,MIDDLE_INITIAL,JOB_ID,MANAGER_ID,HIRE_DATE,SALARY,DEPARTMENT_ID) VALUES(7950,'JENSEN','ALICE','B',667,7505,'15/01/1987',750,13);
INSERT INTO employee (EMPLOYEE_ID,LAST_NAME,FIRST_NAME,MIDDLE_INITIAL,JOB_ID,MANAGER_ID,HIRE_DATE,SALARY,DEPARTMENT_ID) VALUES(7954,'MURRAY','JAMES','T',667,7506,'16/01/1987',750,23);

INSERT INTO item VALUES(600,1,100861,42,1,42);
INSERT INTO item VALUES(610,3,100890,58,1,58);
INSERT INTO item VALUES(611,1,100861,45,1,45);
INSERT INTO item VALUES(612,1,100860,30,100,3000);
INSERT INTO item VALUES(601,1,200376,2.4,12,28.8);
INSERT INTO item VALUES(601,2,100860,32,1,32);
INSERT INTO item VALUES(602,1,100870,2.8,20,56);
INSERT INTO item VALUES(604,1,100890,58,3,174);
INSERT INTO item VALUES(604,2,100861,42,2,84);
INSERT INTO item VALUES(604,3,100860,32,12,384);
INSERT INTO item VALUES(603,1,100860,32,7,224);
INSERT INTO item VALUES(610,1,100860,35,1,35);
INSERT INTO item VALUES(610,2,100870,2.8,3,8.4);
INSERT INTO item VALUES(613,4,200376,2.2,200,440);
INSERT INTO item VALUES(614,1,100860,35,444,15540);
INSERT INTO item VALUES(614,2,100870,2.8,1000,2800);
INSERT INTO item VALUES(612,2,100861,40.5,20,810);
INSERT INTO item VALUES(612,3,101863,10,150,1500);
INSERT INTO item VALUES(620,1,100860,35,10,350);
INSERT INTO item VALUES(620,2,200376,2.4,1000,2400);
INSERT INTO item VALUES(620,3,102130,3.4,500,1700);
INSERT INTO item VALUES(613,1,100871,5.6,100,560);
INSERT INTO item VALUES(613,2,101860,24,200,4800);
INSERT INTO item VALUES(613,3,200380,4,150,600);
INSERT INTO item VALUES(619,3,102130,3.4,100,340);
INSERT INTO item VALUES(617,1,100860,35,50,1750);
INSERT INTO item VALUES(617,2,100861,45,100,4500);
INSERT INTO item VALUES(614,3,100871,5.6,1000,5600);
INSERT INTO item VALUES(616,1,100861,45,10,450);
INSERT INTO item VALUES(616,2,100870,2.8,50,140);
INSERT INTO item VALUES(616,3,100890,58,2,116);
INSERT INTO item VALUES(616,4,102130,3.4,10,34);
INSERT INTO item VALUES(616,5,200376,2.4,10,24);
INSERT INTO item VALUES(619,1,200380,4,100,400);
INSERT INTO item VALUES(619,2,200376,2.4,100,240);
INSERT INTO item VALUES(615,1,100861,45,4,180);
INSERT INTO item VALUES(607,1,100871,5.6,1,5.6);
INSERT INTO item VALUES(615,2,100870,2.8,100,280);
INSERT INTO item VALUES(617,3,100870,2.8,500,1400);
INSERT INTO item VALUES(617,4,100871,5.6,500,2800);
INSERT INTO item VALUES(617,5,100890,58,500,29000);
INSERT INTO item VALUES(617,6,101860,24,100,2400);
INSERT INTO item VALUES(617,7,101863,12.5,200,2500);
INSERT INTO item VALUES(617,8,102130,3.4,100,340);
INSERT INTO item VALUES(617,9,200376,2.4,200,480);
INSERT INTO item VALUES(617,10,200380,4,300,1200);
INSERT INTO item VALUES(609,2,100870,2.5,5,12.5);
INSERT INTO item VALUES(609,3,100890,50,1,50);
INSERT INTO item VALUES(618,1,100860,35,23,805);
INSERT INTO item VALUES(618,2,100861,45,50,2250);
INSERT INTO item VALUES(618,3,100870,2.8,10,28);
INSERT INTO item VALUES(621,1,100861,45,10,450);
INSERT INTO item VALUES(621,2,100870,2.8,100,280);
INSERT INTO item VALUES(615,3,100871,5,50,250);
INSERT INTO item VALUES(608,1,101860,24,1,24);
INSERT INTO item VALUES(608,2,100871,5.6,2,11.2);
INSERT INTO item VALUES(609,1,100861,40,1,40);
INSERT INTO item VALUES(606,1,102130,3.4,1,3.4);
INSERT INTO item VALUES(605,1,100861,45,100,4500);
INSERT INTO item VALUES(605,2,100870,2.8,500,1400);
INSERT INTO item VALUES(605,3,100890,58,5,290);
INSERT INTO item VALUES(605,4,101860,24,50,1200);
INSERT INTO item VALUES(605,5,101863,9.5,100,950);
INSERT INTO item VALUES(605,6,102130,3.4,10,34);
INSERT INTO item VALUES(612,4,100871,5.5,100,550);
INSERT INTO item VALUES(619,4,100871,5.6,50,280);
INSERT INTO item VALUES(509,1,105123,35,30,1050);
INSERT INTO item VALUES(509,2,105124,9,10,90);
INSERT INTO item VALUES(509,3,102136,3.4,10,34);
INSERT INTO item VALUES(523,1,102136,3.4,10,34);
INSERT INTO item VALUES(523,2,105123,37.7,30,1131);
INSERT INTO item VALUES(549,1,105123,38,5,190);
INSERT INTO item VALUES(549,2,105127,6,30,180);
INSERT INTO item VALUES(549,3,105125,3,200,600);
INSERT INTO item VALUES(549,4,105124,13,50,650);
INSERT INTO item VALUES(507,1,105123,35.3,20,706);
INSERT INTO item VALUES(507,2,105124,9,20,180);
INSERT INTO item VALUES(516,1,105124,9,60,540);
INSERT INTO item VALUES(516,2,102136,3.2,250,800);
INSERT INTO item VALUES(516,3,105125,1.9,250,475);
INSERT INTO item VALUES(553,1,105127,6,500,3000);
INSERT INTO item VALUES(553,2,200376,1.75,800,1400);
INSERT INTO item VALUES(526,1,105123,32,100,3200);
INSERT INTO item VALUES(526,2,105124,9,500,4500);
INSERT INTO item VALUES(543,1,105123,34,100,3400);
INSERT INTO item VALUES(543,2,105124,10,500,5000);
INSERT INTO item VALUES(555,1,105123,34,100,3400);
INSERT INTO item VALUES(555,2,105124,10,500,5000);
INSERT INTO item VALUES(555,3,102136,2.8,50,140);
INSERT INTO item VALUES(559,1,105123,40,5,200);
INSERT INTO item VALUES(559,2,105124,15,5,75);
INSERT INTO item VALUES(559,3,105127,6,5,30);
INSERT INTO item VALUES(559,4,102136,3.4,3,10.2);
INSERT INTO item VALUES(559,5,200376,2.4,30,72);
INSERT INTO item VALUES(528,1,105123,37.7,100,3770);
INSERT INTO item VALUES(531,1,105124,11,100,1100);
INSERT INTO item VALUES(531,2,102136,3,100,300);
INSERT INTO item VALUES(558,1,105124,14,100,1400);
INSERT INTO item VALUES(558,2,102136,3,100,300);
INSERT INTO item VALUES(525,1,105123,37.7,10,377);
INSERT INTO item VALUES(552,1,105123,40,10,400);
INSERT INTO item VALUES(552,2,105124,15,10,150);
INSERT INTO item VALUES(552,3,102136,3.4,1,3.4);
INSERT INTO item VALUES(552,4,200376,2.4,1,2.4);
INSERT INTO item VALUES(556,1,102136,3.4,25,85);
INSERT INTO item VALUES(560,1,200376,2.4,30,72);
INSERT INTO item VALUES(565,1,105123,37,100,3700);
INSERT INTO item VALUES(565,2,105124,12,100,1200);
INSERT INTO item VALUES(574,1,104350,41.8,25,1045);
INSERT INTO item VALUES(574,2,200380,3.2,200,640);
INSERT INTO item VALUES(576,1,104350,44,10,440);
INSERT INTO item VALUES(576,2,104351,26,10,260);
INSERT INTO item VALUES(576,3,104362,4.25,170,722.5);
INSERT INTO item VALUES(576,4,200376,2.16,90,194.4);
INSERT INTO item VALUES(576,5,200380,3.4,130,442);
INSERT INTO item VALUES(503,1,104350,38,30,1140);
INSERT INTO item VALUES(503,2,104351,23.6,10,236);
INSERT INTO item VALUES(503,3,104352,50,10,500);
INSERT INTO item VALUES(518,1,104350,38,25,950);
INSERT INTO item VALUES(518,2,104351,23.6,20,472);
INSERT INTO item VALUES(518,3,104360,36,20,720);
INSERT INTO item VALUES(518,4,104362,4.25,170,722.5);
INSERT INTO item VALUES(518,5,102134,3.4,20,68);
INSERT INTO item VALUES(517,1,104352,50,15,750);
INSERT INTO item VALUES(517,2,102134,3.4,10,34);
INSERT INTO item VALUES(544,1,104350,44,15,660);
INSERT INTO item VALUES(544,2,104351,26,15,390);
INSERT INTO item VALUES(544,3,104352,58.3,10,583);
INSERT INTO item VALUES(544,4,104361,50,10,500);
INSERT INTO item VALUES(544,5,104362,4.5,50,225);
INSERT INTO item VALUES(524,1,104350,42,10,420);
INSERT INTO item VALUES(524,2,104351,23.56,35,824.6);
INSERT INTO item VALUES(524,3,104362,4.25,150,637.5);
INSERT INTO item VALUES(524,4,102134,3.23,30,96.9);
INSERT INTO item VALUES(502,1,104352,50,10,500);
INSERT INTO item VALUES(539,1,104351,26,20,520);
INSERT INTO item VALUES(539,2,104360,39,20,780);
INSERT INTO item VALUES(511,1,104351,23.6,15,354);
INSERT INTO item VALUES(511,2,104362,4.5,50,225);
INSERT INTO item VALUES(511,3,102134,3.4,20,68);
INSERT INTO item VALUES(512,1,104360,36,10,360);
INSERT INTO item VALUES(512,2,102134,3.4,20,68);
INSERT INTO item VALUES(562,1,104351,24.7,25,617.5);
INSERT INTO item VALUES(562,2,104352,58.3,15,874.5);
INSERT INTO item VALUES(562,3,104362,4.25,130,552.5);
INSERT INTO item VALUES(529,1,104350,39.89,30,1196.7);
INSERT INTO item VALUES(529,2,102134,3.4,20,68);
INSERT INTO item VALUES(563,1,104352,58.3,10,583);
INSERT INTO item VALUES(563,2,200376,2.04,150,306);
INSERT INTO item VALUES(568,1,104351,24.7,30,741);
INSERT INTO item VALUES(568,2,200376,2.04,110,224.4);
INSERT INTO item VALUES(568,3,200380,3.6,70,252);
INSERT INTO item VALUES(504,1,104350,40,10,400);
INSERT INTO item VALUES(504,2,104351,22.42,35,784.7);
INSERT INTO item VALUES(504,3,104352,50,5,250);
INSERT INTO item VALUES(538,1,104351,24.7,30,741);
INSERT INTO item VALUES(535,1,104352,54,15,810);
INSERT INTO item VALUES(578,1,104350,41.8,40,1672);
INSERT INTO item VALUES(578,2,200376,2.04,190,387.6);
INSERT INTO item VALUES(578,3,200380,3.6,60,216);
INSERT INTO item VALUES(534,1,104350,42,10,420);
INSERT INTO item VALUES(536,1,104350,39.89,40,1595.6);
INSERT INTO item VALUES(536,2,104352,54,10,540);
INSERT INTO item VALUES(572,1,104351,24.7,25,617.5);
INSERT INTO item VALUES(572,2,104352,58.3,10,583);
INSERT INTO item VALUES(514,1,104350,38,30,1140);
INSERT INTO item VALUES(521,1,104350,40,20,800);
INSERT INTO item VALUES(521,2,102134,3.23,30,96.9);
INSERT INTO item VALUES(551,1,104350,44,10,440);
INSERT INTO item VALUES(551,2,104361,50,5,250);
INSERT INTO item VALUES(551,3,102134,3.4,20,68);
INSERT INTO item VALUES(551,4,200376,1.92,200,384);
INSERT INTO item VALUES(513,1,104350,40,15,600);
INSERT INTO item VALUES(513,2,104351,23.6,20,472);
INSERT INTO item VALUES(513,3,104362,4.25,100,425);
INSERT INTO item VALUES(508,1,104360,36,20,720);
INSERT INTO item VALUES(508,2,104362,4.5,80,360);
INSERT INTO item VALUES(515,1,104350,40,20,800);
INSERT INTO item VALUES(515,2,104351,22.42,25,560.5);
INSERT INTO item VALUES(515,3,102134,3.4,20,68);
INSERT INTO item VALUES(542,1,104350,41.8,25,1045);
INSERT INTO item VALUES(542,2,104360,39,20,780);
INSERT INTO item VALUES(542,3,104361,50,11,550);
INSERT INTO item VALUES(542,4,102134,3.4,10,34);
INSERT INTO item VALUES(573,1,103120,22.5,50,1125);
INSERT INTO item VALUES(573,2,103131,4.04,50,202);
INSERT INTO item VALUES(573,3,103141,20,15,300);
INSERT INTO item VALUES(566,1,103120,23.75,40,950);
INSERT INTO item VALUES(566,2,103121,27,50,1350);
INSERT INTO item VALUES(566,3,103130,3.77,60,226.2);
INSERT INTO item VALUES(566,4,103131,3.9,170,663);
INSERT INTO item VALUES(566,5,103141,20,10,200);
INSERT INTO item VALUES(520,1,103130,4,10,40);
INSERT INTO item VALUES(520,2,103131,3.77,80,301.6);
INSERT INTO item VALUES(519,1,103130,3.5,110,385);
INSERT INTO item VALUES(519,2,103140,19,30,570);
INSERT INTO item VALUES(575,1,103140,19,30,570);
INSERT INTO item VALUES(575,2,200380,3.8,30,114);
INSERT INTO item VALUES(547,1,103130,3.77,80,301.6);
INSERT INTO item VALUES(547,2,103131,4.04,70,282.8);
INSERT INTO item VALUES(547,3,103140,20,15,300);
INSERT INTO item VALUES(547,4,103141,20,5,100);
INSERT INTO item VALUES(540,1,103130,3.98,40,159.2);
INSERT INTO item VALUES(540,2,103131,3.9,180,702);
INSERT INTO item VALUES(567,1,103140,20,10,200);
INSERT INTO item VALUES(570,1,103131,4.04,90,363.6);
INSERT INTO item VALUES(570,2,103140,20,15,300);
INSERT INTO item VALUES(571,1,103131,4.04,70,282.8);
INSERT INTO item VALUES(571,2,103140,19,25,475);
INSERT INTO item VALUES(571,3,102132,3.4,15,51);
INSERT INTO item VALUES(571,4,200376,2.16,80,172.8);
INSERT INTO item VALUES(571,5,200380,3.8,30,114);
INSERT INTO item VALUES(541,1,103140,20,10,200);
INSERT INTO item VALUES(541,2,103141,20,10,200);
INSERT INTO item VALUES(532,1,103120,21.59,60,1295.4);
INSERT INTO item VALUES(527,1,103120,21.59,60,1295.4);
INSERT INTO item VALUES(527,2,103121,27.35,40,1094);
INSERT INTO item VALUES(527,3,103140,19,35,665);
INSERT INTO item VALUES(501,1,103130,3.6,60,216);
INSERT INTO item VALUES(564,1,103130,3.77,80,301.6);
INSERT INTO item VALUES(564,2,103131,3.9,120,468);
INSERT INTO item VALUES(564,3,102132,3.23,40,129.2);
INSERT INTO item VALUES(537,1,103130,3.6,160,576);
INSERT INTO item VALUES(537,2,102132,3.23,30,96.9);
INSERT INTO item VALUES(522,1,103120,21.59,80,1727.2);
INSERT INTO item VALUES(522,2,103121,28.8,10,288);
INSERT INTO item VALUES(522,3,103131,4.04,90,363.6);
INSERT INTO item VALUES(522,4,103141,20,10,200);
INSERT INTO item VALUES(554,1,103131,4.04,70,282.8);
INSERT INTO item VALUES(569,1,103120,22.5,50,1125);
INSERT INTO item VALUES(569,2,103130,3.6,180,648);
INSERT INTO item VALUES(569,3,103141,20,15,300);
INSERT INTO item VALUES(550,1,103120,22.5,60,1350);
INSERT INTO item VALUES(550,2,103140,19,45,855);
INSERT INTO item VALUES(550,3,103141,20,5,100);
INSERT INTO item VALUES(550,4,102132,3.4,15,51);
INSERT INTO item VALUES(548,1,103140,19,30,570);
INSERT INTO item VALUES(548,2,102132,3.23,30,96.9);
INSERT INTO item VALUES(505,1,103130,3.5,100,350);
INSERT INTO item VALUES(505,2,103140,20,15,300);
INSERT INTO item VALUES(577,1,103121,30,20,600);
INSERT INTO item VALUES(577,2,103131,3.9,150,585);
INSERT INTO item VALUES(577,3,102132,3.23,25,80.75);
INSERT INTO item VALUES(533,1,103121,27.35,30,820.5);
INSERT INTO item VALUES(533,2,103130,3.77,80,301.6);
INSERT INTO item VALUES(561,1,103120,22.5,80,1800);
INSERT INTO item VALUES(561,2,103130,3.77,70,263.9);
INSERT INTO item VALUES(561,3,103141,20,15,300);
INSERT INTO item VALUES(561,4,200376,2.16,90,194.4);
INSERT INTO item VALUES(506,1,103120,20.88,80,1670.4);
INSERT INTO item VALUES(506,2,103130,3.5,180,630);
INSERT INTO item VALUES(506,3,103141,20,15,300);
INSERT INTO item VALUES(530,1,103121,25.91,50,1295.5);
INSERT INTO item VALUES(530,2,103130,3.6,200,720);
INSERT INTO item VALUES(530,3,103140,19,40,760);
INSERT INTO item VALUES(530,4,103141,20,10,200);
INSERT INTO item VALUES(530,5,102132,3.4,15,51);
INSERT INTO item VALUES(545,1,103140,19,25,475);
INSERT INTO item VALUES(557,1,103120,23.75,40,950);
INSERT INTO item VALUES(557,2,103121,30,10,300);
INSERT INTO item VALUES(557,3,103140,19,35,665);
INSERT INTO item VALUES(557,4,200376,2.16,80,172.8);
INSERT INTO item VALUES(557,5,200380,3.4,110,374);
INSERT INTO item VALUES(546,1,103120,22.5,50,1125);
INSERT INTO item VALUES(546,2,103121,30,20,600);
INSERT INTO item VALUES(546,3,103130,3.6,120,432);
INSERT INTO item VALUES(546,4,103131,3.9,140,546);
INSERT INTO item VALUES(546,5,103140,19,40,760);
INSERT INTO item VALUES(546,6,103141,20,10,200);
INSERT INTO item VALUES(510,1,103120,20.88,60,1252.8);
INSERT INTO item VALUES(510,2,103131,4.19,20,83.8);

INSERT INTO job VALUES(667,'CLERK');
INSERT INTO job VALUES(668,'STAFF');
INSERT INTO job VALUES(669,'ANALYST');
INSERT INTO job VALUES(670,'SALESPERSON');
INSERT INTO job VALUES(671,'MANAGER');
INSERT INTO job VALUES(672,'PRESIDENT');

INSERT INTO location VALUES(122,'NEW YORK');
INSERT INTO location VALUES(124,'DALLAS');
INSERT INTO location VALUES(123,'CHICAGO');
INSERT INTO location VALUES(167,'BOSTON');

INSERT INTO price VALUES(100871,4.8,3.2,'01/01/1989','01/12/1989');
INSERT INTO price (PRODUCT_ID,LIST_PRICE,MIN_PRICE,START_DATE) VALUES(100890,58,46.4,'01/01/1989');
INSERT INTO price VALUES(100890,54,40.5,'01/06/1988','31/12/1988');
INSERT INTO price (PRODUCT_ID,LIST_PRICE,MIN_PRICE,START_DATE) VALUES(100860,35,28,'01/06/1990');
INSERT INTO price VALUES(100860,32,25.6,'01/01/1990','31/05/1990');
INSERT INTO price VALUES(100860,30,24,'01/01/1989','31/12/1989');
INSERT INTO price (PRODUCT_ID,LIST_PRICE,MIN_PRICE,START_DATE) VALUES(100861,45,36,'01/06/1990');
INSERT INTO price VALUES(100861,42,33.6,'01/01/1990','31/05/1990');
INSERT INTO price VALUES(100861,39,31.2,'01/01/1989','31/12/1989');
INSERT INTO price (PRODUCT_ID,LIST_PRICE,MIN_PRICE,START_DATE) VALUES(100870,2.8,2.4,'01/01/1990');
INSERT INTO price VALUES(100870,2.4,1.9,'01/01/1989','01/12/1989');
INSERT INTO price (PRODUCT_ID,LIST_PRICE,MIN_PRICE,START_DATE) VALUES(100871,5.6,4.8,'01/01/1990');
INSERT INTO price (PRODUCT_ID,LIST_PRICE,MIN_PRICE,START_DATE) VALUES(101860,24,18,'15/02/1989');
INSERT INTO price (PRODUCT_ID,LIST_PRICE,MIN_PRICE,START_DATE) VALUES(101863,12.5,9.4,'15/02/1989');
INSERT INTO price (PRODUCT_ID,LIST_PRICE,MIN_PRICE,START_DATE) VALUES(102130,3.4,2.8,'18/08/1989');
INSERT INTO price (PRODUCT_ID,LIST_PRICE,MIN_PRICE,START_DATE) VALUES(200376,2.4,1.75,'15/11/1990');
INSERT INTO price (PRODUCT_ID,LIST_PRICE,MIN_PRICE,START_DATE) VALUES(200380,4,3.2,'15/11/1990');
INSERT INTO price VALUES(103120,23.2,18.6,'01/01/1989','31/12/1989');
INSERT INTO price VALUES(103120,24,19.2,'01/01/1990','31/05/1990');
INSERT INTO price (PRODUCT_ID,LIST_PRICE,MIN_PRICE,START_DATE) VALUES(103120,25,20,'01/06/1990');
INSERT INTO price VALUES(103121,27.8,22.3,'01/01/1989','31/12/1989');
INSERT INTO price VALUES(103121,28.8,23,'01/01/1990','31/05/1990');
INSERT INTO price (PRODUCT_ID,LIST_PRICE,MIN_PRICE,START_DATE) VALUES(103121,30,24,'01/06/1990');
INSERT INTO price VALUES(103130,4,3.5,'01/01/1989','31/12/1989');
INSERT INTO price (PRODUCT_ID,LIST_PRICE,MIN_PRICE,START_DATE) VALUES(103130,4.2,3.6,'01/01/1990');
INSERT INTO price VALUES(103131,4.2,3.6,'01/01/1989','31/12/1989');
INSERT INTO price (PRODUCT_ID,LIST_PRICE,MIN_PRICE,START_DATE) VALUES(103131,4.5,3.9,'01/01/1990');
INSERT INTO price (PRODUCT_ID,LIST_PRICE,MIN_PRICE,START_DATE) VALUES(103140,20,15,'15/02/1989');
INSERT INTO price (PRODUCT_ID,LIST_PRICE,MIN_PRICE,START_DATE) VALUES(103141,20,15,'15/02/1989');
INSERT INTO price (PRODUCT_ID,LIST_PRICE,MIN_PRICE,START_DATE) VALUES(102132,3.4,2.8,'18/08/1989');
INSERT INTO price VALUES(104350,40,32,'01/01/1989','31/12/1989');
INSERT INTO price VALUES(104350,42,33.6,'01/01/1990','31/05/1990');
INSERT INTO price (PRODUCT_ID,LIST_PRICE,MIN_PRICE,START_DATE) VALUES(104350,44,35.3,'01/06/1990');
INSERT INTO price VALUES(104351,23.6,18.9,'01/01/1989','31/12/1989');
INSERT INTO price VALUES(104351,24.8,19.8,'01/01/1990','31/05/1990');
INSERT INTO price (PRODUCT_ID,LIST_PRICE,MIN_PRICE,START_DATE) VALUES(104351,26,20.8,'01/06/1990');
INSERT INTO price VALUES(104352,50,35,'01/01/1989','31/12/1989');
INSERT INTO price VALUES(104352,54,37.8,'01/01/1990','31/05/1990');
INSERT INTO price (PRODUCT_ID,LIST_PRICE,MIN_PRICE,START_DATE) VALUES(104352,58.3,40.8,'01/06/1990');
INSERT INTO price VALUES(104360,36,29.5,'01/01/1989','31/12/1989');
INSERT INTO price (PRODUCT_ID,LIST_PRICE,MIN_PRICE,START_DATE) VALUES(104360,39,32,'01/01/1990');
INSERT INTO price VALUES(104361,47,33,'01/01/1989','31/12/1989');
INSERT INTO price (PRODUCT_ID,LIST_PRICE,MIN_PRICE,START_DATE) VALUES(104361,50,35,'01/01/1990');
INSERT INTO price (PRODUCT_ID,LIST_PRICE,MIN_PRICE,START_DATE) VALUES(104362,5,4,'15/02/1989');
INSERT INTO price (PRODUCT_ID,LIST_PRICE,MIN_PRICE,START_DATE) VALUES(102134,3.4,2.8,'18/08/1989');
INSERT INTO price VALUES(105123,36.3,29,'01/01/1989','31/12/1989');
INSERT INTO price VALUES(105123,37.7,32,'01/01/1990','31/05/1990');
INSERT INTO price (PRODUCT_ID,LIST_PRICE,MIN_PRICE,START_DATE) VALUES(105123,40,34,'01/06/1990');
INSERT INTO price VALUES(105124,10,7.6,'01/01/1989','31/12/1989');
INSERT INTO price VALUES(105124,12,9,'01/01/1990','31/05/1990');
INSERT INTO price (PRODUCT_ID,LIST_PRICE,MIN_PRICE,START_DATE) VALUES(105124,15,10,'01/06/1990');
INSERT INTO price VALUES(105125,2,1.7,'01/01/1989','31/12/1989');
INSERT INTO price (PRODUCT_ID,LIST_PRICE,MIN_PRICE,START_DATE) VALUES(105125,3,2.6,'01/01/1990');
INSERT INTO price VALUES(105126,5,4.3,'01/01/1989','31/12/1989');
INSERT INTO price (PRODUCT_ID,LIST_PRICE,MIN_PRICE,START_DATE) VALUES(105126,6,5,'01/01/1990');
INSERT INTO price (PRODUCT_ID,LIST_PRICE,MIN_PRICE,START_DATE) VALUES(105127,6,5,'15/11/1990');
INSERT INTO price (PRODUCT_ID,LIST_PRICE,MIN_PRICE,START_DATE) VALUES(105128,10,8,'15/11/1990');
INSERT INTO price (PRODUCT_ID,LIST_PRICE,MIN_PRICE,START_DATE) VALUES(102136,3.4,2.8,'18/08/1989');

INSERT INTO product VALUES(100860,'ACE TENNIS RACKET I');
INSERT INTO product VALUES(100861,'ACE TENNIS RACKET II');
INSERT INTO product VALUES(100870,'ACE TENNIS BALLS-3 PACK');
INSERT INTO product VALUES(100871,'ACE TENNIS BALLS-6 PACK');
INSERT INTO product VALUES(100890,'ACE TENNIS NET');
INSERT INTO product VALUES(101860,'SP TENNIS RACKET');
INSERT INTO product VALUES(101863,'SP JUNIOR RACKET');
INSERT INTO product VALUES(102130,'RH: "GUIDE TO TENNIS"');
INSERT INTO product VALUES(200376,'SB ENERGY BAR-6 PACK');
INSERT INTO product VALUES(200380,'SB VITA SNACK-6 PACK');
INSERT INTO product VALUES(103120,'WIFF SOFTBALL BAT I');
INSERT INTO product VALUES(103121,'WIFF SOFTBALL BAT II');
INSERT INTO product VALUES(103130,'WIFF SOFTBALL, SMALL');
INSERT INTO product VALUES(103131,'WIFF SOFTBALL, LARGE');
INSERT INTO product VALUES(103140,'WIFF SOFTBALL MITT (LH)');
INSERT INTO product VALUES(103141,'WIFF SOFTBALL MITT (RH)');
INSERT INTO product VALUES(102132,'RH: "GUIDE TO SOFTBALL"');
INSERT INTO product VALUES(104350,'DUNK BASKETBALL INDOOR');
INSERT INTO product VALUES(104351,'DUNK BASKETBALL OUTDOOR');
INSERT INTO product VALUES(104352,'DUNK BASKETBALL PROFESSIONAL');
INSERT INTO product VALUES(104360,'DUNK HOOP');
INSERT INTO product VALUES(104361,'DUNK HOOP W/FIBERGLASS BOARD');
INSERT INTO product VALUES(104362,'DUNK NETS - RAINBOW');
INSERT INTO product VALUES(102134,'RH: "GUIDE TO BASKETBALL"');
INSERT INTO product VALUES(105123,'YELLOW JERSEY BICYCLE HELMET');
INSERT INTO product VALUES(105124,'YELLOW JERSEY BICYCLE GLOVES');
INSERT INTO product VALUES(105125,'YELLOW JERSEY WATER BOTTLE');
INSERT INTO product VALUES(105126,'YELLOW JERSEY BOTTLE CAGE');
INSERT INTO product VALUES(105127,'YELLOW JERSEY FRAME PUMP');
INSERT INTO product VALUES(105128,'YELLOW JERSEY SADDLE PACK');
INSERT INTO product VALUES(102136,'RH: "GUIDE TO CYCLING"');

INSERT INTO sales_order VALUES(610,'07/01/1991',101,'08/01/1991',101.4);
INSERT INTO sales_order VALUES(611,'11/01/1991',102,'11/01/1991',45);
INSERT INTO sales_order VALUES(612,'15/01/1991',104,'20/01/1991',5860);
INSERT INTO sales_order VALUES(601,'01/05/1990',106,'30/05/1990',60.8);
INSERT INTO sales_order VALUES(602,'05/06/1990',102,'20/06/1990',56);
INSERT INTO sales_order VALUES(600,'01/05/1990',103,'29/05/1990',42);
INSERT INTO sales_order VALUES(604,'15/06/1990',106,'30/06/1990',642);
INSERT INTO sales_order VALUES(605,'14/07/1990',106,'30/07/1990',8374);
INSERT INTO sales_order VALUES(606,'14/07/1990',100,'30/07/1990',3.4);
INSERT INTO sales_order VALUES(609,'01/08/1990',100,'15/08/1990',102.5);
INSERT INTO sales_order VALUES(607,'18/07/1990',104,'18/07/1990',5.6);
INSERT INTO sales_order VALUES(608,'25/07/1990',104,'25/07/1990',35.2);
INSERT INTO sales_order VALUES(603,'05/06/1990',102,'05/06/1990',224);
INSERT INTO sales_order VALUES(620,'12/03/1991',100,'12/03/1991',4450);
INSERT INTO sales_order VALUES(613,'01/02/1991',108,'01/02/1991',6400);
INSERT INTO sales_order VALUES(614,'01/02/1991',102,'05/02/1991',23940);
INSERT INTO sales_order VALUES(616,'03/02/1991',103,'10/02/1991',764);
INSERT INTO sales_order VALUES(619,'22/02/1991',104,'04/03/1991',1260);
INSERT INTO sales_order VALUES(617,'05/02/1991',105,'03/03/1991',46370);
INSERT INTO sales_order VALUES(615,'01/02/1991',107,'06/02/1991',710);
INSERT INTO sales_order VALUES(618,'15/02/1991',102,'06/03/1991',3083);
INSERT INTO sales_order VALUES(621,'15/03/1991',100,'01/04/1991',730);
INSERT INTO sales_order VALUES(509,'04/06/1989',226,'10/06/1989',1174);
INSERT INTO sales_order VALUES(523,'13/02/1990',226,'13/02/1990',1165);
INSERT INTO sales_order VALUES(549,'27/12/1990',226,'14/01/1991',1620);
INSERT INTO sales_order VALUES(507,'26/05/1989',228,'27/05/1989',886);
INSERT INTO sales_order VALUES(516,'30/09/1989',228,'03/10/1989',1815);
INSERT INTO sales_order VALUES(553,'02/02/1991',228,'13/02/1991',4400);
INSERT INTO sales_order VALUES(526,'04/03/1990',221,'07/03/1990',7700);
INSERT INTO sales_order VALUES(543,'04/09/1990',221,'07/09/1990',8400);
INSERT INTO sales_order VALUES(555,'04/03/1991',221,'07/03/1991',8540);
INSERT INTO sales_order VALUES(559,'16/11/1990',222,'23/04/1991',387.2);
INSERT INTO sales_order VALUES(528,'24/03/1990',224,'24/03/1990',3770);
INSERT INTO sales_order VALUES(531,'31/03/1990',224,'02/04/1990',1400);
INSERT INTO sales_order VALUES(558,'31/03/1991',224,'02/04/1991',1700);
INSERT INTO sales_order VALUES(525,'28/02/1990',225,'03/03/1990',377);
INSERT INTO sales_order VALUES(552,'02/02/1991',223,'07/02/1991',555.8);
INSERT INTO sales_order VALUES(556,'10/03/1991',223,'12/03/1991',85);
INSERT INTO sales_order VALUES(560,'25/04/1991',223,'25/04/1991',72);
INSERT INTO sales_order VALUES(565,'01/06/1991',227,'03/06/1991',4900);
INSERT INTO sales_order VALUES(574,'10/10/1991',201,'12/10/1991',1685);
INSERT INTO sales_order VALUES(576,'13/10/1991',201,'18/10/1991',2058.9);
INSERT INTO sales_order VALUES(503,'25/03/1989',201,'06/04/1989',1876);
INSERT INTO sales_order VALUES(518,'20/10/1989',201,'05/11/1989',2932.5);
INSERT INTO sales_order VALUES(517,'23/10/1989',201,'07/11/1989',784);
INSERT INTO sales_order VALUES(544,'11/09/1990',202,'15/09/1990',2358);
INSERT INTO sales_order VALUES(524,'22/02/1990',202,'04/03/1990',1979);
INSERT INTO sales_order VALUES(502,'10/02/1989',202,'23/02/1989',500);
INSERT INTO sales_order VALUES(539,'26/06/1990',202,'03/07/1990',1300);
INSERT INTO sales_order VALUES(511,'17/08/1989',202,'21/08/1989',647);
INSERT INTO sales_order VALUES(512,'28/08/1989',203,'13/09/1989',428);
INSERT INTO sales_order VALUES(562,'04/05/1991',203,'19/05/1991',2044.5);
INSERT INTO sales_order VALUES(529,'02/04/1990',203,'05/04/1990',1264.7);
INSERT INTO sales_order VALUES(563,'25/05/1991',204,'26/05/1991',889);
INSERT INTO sales_order VALUES(568,'13/07/1991',204,'21/07/1991',1217.4);
INSERT INTO sales_order VALUES(504,'11/04/1989',204,'12/04/1989',1434.7);
INSERT INTO sales_order VALUES(538,'23/06/1990',204,'26/06/1990',741);
INSERT INTO sales_order VALUES(535,'28/05/1990',204,'09/06/1990',810);
INSERT INTO sales_order VALUES(578,'19/11/1991',204,'04/12/1991',2275.6);
INSERT INTO sales_order VALUES(534,'11/05/1990',206,'15/05/1990',420);
INSERT INTO sales_order VALUES(536,'21/05/1990',206,'06/06/1990',2135.6);
INSERT INTO sales_order VALUES(572,'19/08/1991',206,'24/08/1991',1200.5);
INSERT INTO sales_order VALUES(514,'05/09/1989',207,'16/09/1989',1140);
INSERT INTO sales_order VALUES(521,'20/11/1989',207,'23/11/1989',896.9);
INSERT INTO sales_order VALUES(551,'22/01/1991',208,'06/02/1991',1142);
INSERT INTO sales_order VALUES(513,'06/09/1989',208,'14/09/1989',1497);
INSERT INTO sales_order VALUES(508,'26/05/1989',208,'08/06/1989',1080);
INSERT INTO sales_order VALUES(515,'19/09/1989',208,'26/09/1989',1428.5);
INSERT INTO sales_order VALUES(542,'11/08/1990',208,'23/08/1990',2409);
INSERT INTO sales_order VALUES(573,'10/10/1991',201,'12/10/1991',1627);
INSERT INTO sales_order VALUES(566,'09/06/1991',201,'12/06/1991',3389.2);
INSERT INTO sales_order VALUES(520,'16/11/1989',201,'19/11/1989',341.6);
INSERT INTO sales_order VALUES(519,'20/10/1989',201,'05/11/1989',955);
INSERT INTO sales_order VALUES(575,'04/10/1991',201,'17/10/1991',684);
INSERT INTO sales_order VALUES(547,'16/10/1990',202,'27/10/1990',984.4);
INSERT INTO sales_order VALUES(540,'15/07/1990',202,'17/07/1990',861.2);
INSERT INTO sales_order VALUES(567,'05/07/1991',202,'07/07/1991',200);
INSERT INTO sales_order VALUES(570,'17/07/1991',202,'24/07/1991',663.6);
INSERT INTO sales_order VALUES(571,'02/08/1991',202,'12/08/1991',1095.6);
INSERT INTO sales_order VALUES(541,'08/08/1990',203,'18/08/1990',400);
INSERT INTO sales_order VALUES(532,'08/04/1990',203,'21/04/1990',1295.4);
INSERT INTO sales_order VALUES(527,'27/02/1990',204,'14/03/1990',3054.4);
INSERT INTO sales_order VALUES(501,'06/01/1989',204,'11/01/1989',216);
INSERT INTO sales_order VALUES(564,'25/05/1991',204,'26/05/1991',898.8);
INSERT INTO sales_order VALUES(537,'14/06/1990',204,'26/06/1990',672.9);
INSERT INTO sales_order VALUES(522,'07/01/1990',204,'10/01/1990',2578.8);
INSERT INTO sales_order VALUES(554,'18/02/1991',204,'22/02/1991',282.8);
INSERT INTO sales_order VALUES(569,'16/07/1991',205,'23/07/1991',2073);
INSERT INTO sales_order VALUES(550,'27/01/1991',205,'07/02/1991',2356);
INSERT INTO sales_order VALUES(548,'26/11/1990',205,'12/12/1990',666.9);
INSERT INTO sales_order VALUES(505,'07/04/1989',206,'22/04/1989',650);
INSERT INTO sales_order VALUES(577,'06/10/1991',206,'20/10/1991',1265.75);
INSERT INTO sales_order VALUES(533,'28/04/1990',206,'02/05/1990',1122.1);
INSERT INTO sales_order VALUES(561,'20/04/1991',207,'07/05/1991',2558.3);
INSERT INTO sales_order VALUES(506,'27/04/1989',208,'10/05/1989',2600.4);
INSERT INTO sales_order VALUES(530,'03/04/1990',208,'07/04/1990',3026.5);
INSERT INTO sales_order VALUES(545,'06/10/1990',208,'13/10/1990',475);
INSERT INTO sales_order VALUES(557,'08/03/1991',208,'12/03/1991',2461.8);
INSERT INTO sales_order VALUES(546,'17/10/1990',208,'23/10/1990',3663);
INSERT INTO sales_order VALUES(510,'18/07/1989',208,'21/07/1989',1336.6);

ALTER TABLE PRICE ADD 
	FOREIGN KEY (Product_id) 
	REFERENCES Product (Product_id)

ALTER TABLE ITEM ADD
	FOREIGN KEY (Product_id)
	REFERENCES Product (Product_id),
	FOREIGN KEY (Order_id)
	REFERENCES Sales_Order (Order_id)

ALTER TABLE SALES_ORDER ADD
	FOREIGN KEY (Customer_id)
	REFERENCES Customer(Customer_id)

ALTER TABLE CUSTOMER ADD
	FOREIGN KEY (Salesperson_id)
	REFERENCES Employee(Employee_id)

ALTER TABLE Employee ADD
	FOREIGN KEY (Manager_id)
	REFERENCES Employee(Employee_id), 
	FOREIGN KEY (Job_id)
	REFERENCES Job(Job_id),
	FOREIGN KEY (Department_id)
	REFERENCES Department(Department_id)

ALTER TABLE Department ADD
	FOREIGN KEY (Location_id)
	REFERENCES Location(Location_id)

